package com.ruoyi.dataserver.constant;

/**
 * @ProjectName
 * @Package com.lab.dataserver.constant
 * @ClassName StatisticConstants
 * @Description 统计常量类
 * @Company lab
 * @Author heff
 * @Date 2020/7/9 11:45
 * @UpdateUser
 * @UpdateDate
 * @UpdateRemark
 * @Version 1.0.0
 */

public class StatisticConstants {
    /**
     * @param 图层类型：管线
     */
    public static String layerType_line = "line";
    /**
     * @param 图层类型：井盖
     */
    public static String layerType_jg = "jg";
    /**
     * Statistic_Type_GJ 统计类型 管径分类统计
     */
    public static String Statistic_Type_GJ = "GJ";
    /**
     * Statistic_Type_GJSegment 统计类型 管径分段统计
     */
    public static String Statistic_Type_GJSegment = "GJSegment";
    /**
     * @param sql脚本连接符前缀 AND
     */
    public static String SQLPreConnector_AND = " AND ";
    /**
     * @param sql脚本连接符前缀 OR
     */
    public static String SQLPreConnector_OR = " OR ";
    /**
     * @param sql脚本连接符前缀 IN
     */
    public static String SQLPreConnector_IN = "IN";
    /**
     * @param sql脚本连接符前缀 LIKE
     */
    public static String SQLPreConnector_LIKE = "LIKE";
    /**
     * @param sql脚本连接符前缀 =
     */
    public static String SQLPreConnector_Eq = "Eq";
    /**
     * @param sql脚本连接符函数 Trim
     */
    public static String SQLPreConnector_Trim = "Trim";
    /**
     * @param sql脚本连接符前缀 WHERE
     */
    public static String SQLPreConnector_WHERE = " WHERE ";

    public static String SQL_LengthStatistic = "sum(cd) as length";
    public static String SQL_CountStatistic = "count(*) as count";


}
